package org.example.webaiproject05.Mapper;

import org.apache.ibatis.annotations.*;
import org.example.webaiproject05.pojo.Dept;

import java.util.List;

@Mapper
public interface DeptMapper {
    //方式一手动结果映射
//    @Results(id = "deptMap", value = {
//            @Result(id = true, property = "id", column = "id"),
//            @Result(property = "name", column = "name"),
//            @Result(property = "createTime", column = "create_time"),
//            @Result(property = "updateTime", column = "update_time")
//    })
    //查询所有的
    //方式二起别名
    @Select("select  id, name, create_time , update_time from dept order by update_time desc;")
    List<Dept> findAll();
    @Delete("delete from dept where id=#{id}")
    void deleteById(Integer id);


    @Insert("insert into dept(name, create_time, update_time) values(#{name}, #{createTime}, #{updateTime})")
    void insert(Dept dept);

    @Select("select id,name,create_time,update_time from dept where id=#{id}")
    Dept getById(Integer id);

    @Update("update dept set name=#{name},update_time=#{updateTime} where id=#{id}")
    void Update(Dept dept);
}
